Bentley Map V8i (SELECTseries 10) Help

Optional Parameters for All Dgn2Sdo File Types

IN_EXTENT=<xmin,ymin,xmax,ymax>: Specifies a spatial extent, used when scanning the input design file.

OUT_DIR=<outdir>: Overrides the default output directory where SQL Loader scripts are placed.

OUT_GEOM_COL=<geometry column name>: Geometry column name to use for generated SDO_GEOMETRY columns. Defaults to "OGC_GEOMETRY".

OUT_CS=<output SRID>: Output coordinate system (Oracle SRID) for the generated spatial layers. Defaults to null.

Example: OUT_CS=81989

Oracle SRIDs can be found in the table MDSYS.CS_SRS.

It looks like:

SQL> describe mdsys.cs_srs;

Name

Null?

Type

CS_NAME

.

VARCHAR2(80)

SRID

NOT NULL

NUMBER(38)

AUTH_SRID

.

NUMBER(38)

AUTH_NAME

.

VARCHAR2(256)

WKTEXT

.

VARCHAR2(2046)

CS_BOUNDS

.

MDSYS.SDO_GEOMETRY

Query the table using a select statement such as:

select CS_NAME, SRID from MDSYS.CS_SRS where CS_NAME like
'British%';

This will return all coordinate systems that start with British in the name.

OUT_GEOM_TOL=<geomtolerance>: The tolerance to set on generated SDO_GEOMETRY columns. Defaults to 0.000000050.

OUT_SPATIAL_INDEX=<TRUE|FALSE>: A flag indicating whether the generated SQL script for creating spatial tables should also contain a SQL statement to create a spatial index for the table. Default is TRUE.

OUT_INDEX_TYPE=<spatialindextype>: An override to the spatial index type. Only used if OUT_SPATIAL_INDEX is set to TRUE. If this argument is not specified, the index type is determined automatically from the input datastream.

Valid parameters are: POINT,LINE or CURVE,POLYGON, COLLECTION, MULTIPOINT, MULTILINE or MULTICURVE, MULTIPOLYGON

OUT_DIM=<2D|3D>: Specify the dimension of the generated spatial layer. Default = 2D.

OUT_XDIM=(min_x,max_x): Override the generated spatial layer limits for the X axis.

OUT_YDIM=(min_y,max_y): Override the generated spatial layer limits for the Y axis.

OUT_ZDIM=(min_z,max_z): Override the generated spatial layer limits for the Z axis.

OUT_PK_COL_NAME=<Primary Key name>: Override the generated name for the primary key column.

OUT_PK_START=<start value>: Override the default starting value for generated Primary Key values.

OUT_DELIM=<char>: Override the field delimiter to use in generated SQL*Loader .DAT files.

OUT_SCHEMA_ONLY=<true|false>: Specifies that table creation and indexing scripts be created, but does not generate any SQL*Loader scripts.

OUT_SCHEMA_FEATURES=<true|false> : Specifies that table creation and indexing scripts be created for all schema features regardless of whether or not instances exist in the input file(s).

IN_WP=<project_config_file>: Specifies a MicroStation project configuration file (.pcf) to use.

IN_WR=<workspace_root>: Specifies an alternate MicroStation workspace root directory to use.